package com.hz.ys_system.dbsql;



import com.hz.framework.MyInterFace.SystemInterFace;

/**
 * *****************************************************************************
 *               Copyright(c) 2010 by 哈尔滨华泽数码科技有限公司.
 *                       All rights reserved.
 *******************************************************************************
 *     File Name         :  com.hz.hzsystem.dbsql.ColumnSql.java
 *     Description(说明)	:  系统管理
 * -----------------------------------------------------------------------------
 *     No.        Date              Revised by           Description	
 *     	1	  Jun 10, 2011           韩飞              Created
 *****************************************************************************
 */
public class SystemSql implements SystemInterFace {
	
//	查询所有下拉选的类别名称
	public static final String SEL_TYPE = "select * from pres_selecttype " +
//			关联人员信息
			" left join hzsyspersonnel on createuser = personid ";
	
//	根据名称tid  查询下拉选的类别名称
	public static final String SEL_TYPEINFO = "select t.*,personname  from pres_selecttype t left join hzsyspersonnel on personid = createuser where tid = ? ";
	
//	根据名称tid  查询下拉选的内容信息
	public static final String SEL_VALUEINFO = "select v.* from pres_selectvalue v left join pres_selecttype on selecttype=typechar where tid = ? order by  CONVERT(selectdsc ,SIGNED)";
	
//	根据标识 查询下拉选的内容信息 
	public static final String SEL_VALUE = "select selectvalue from pres_selectvalue where selecttype = ? order by CONVERT(selectdsc ,SIGNED)";
	
//	查询选中的注册用户信息
	public static final String SEL_USERINFO = "select * from pres_userinfo where selected = 'y'";
	
//	查询所有注册用户信息版本
	public static final String SEL_TIMEINFO = "select createtime,selected from pres_userinfo ";
	
//	查询 机台信息
	public static final String SEL_MACHINE_INFO = "select * from pres_machineinfo where flag = 'y'";
	
//	删除机台信息 假删除
	public static final String DEL_MACHINE  = "update pres_machineinfo set flag = 'n' where id = ?";
	
//	根据id查询机台信息
	public static final String SEL_MACHINE_ONE = "select * from pres_machineinfo where id = ?";
	
}
